Index Designer is the basic Navicat tool for working with indexes. It allows you to create new index and edit the existing index properties.
To open an index in the Index Designer (see Edit Index for details).
- Editing Nonclustered Index Properties
- Editing Clustered Index Properties
- Editing XML Index Properties (Support from SQL Server 2005 or later)
- Editing Spatial Index Properties (Support from SQL Server 2008 or later and SQL Azure)
- Editing Index Comment
- Index SQL Preview